﻿Imports System.Data
Imports System.Data.SqlClient
Imports QuanLyCafe.Menu_DTO
Public Class Menu_DAO
    Public Shared Function GetListMN_DAO()
        Dim str As String = "Select * From MENU"
        Dim conn As SqlConnection
        conn = DataProvider.Connection()
        Dim dt As DataTable
        Dim cmd As SqlCommand
        Dim dataApdap As SqlDataAdapter
        cmd = New SqlCommand(str, conn)
        dt = New DataTable
        dataApdap = New SqlDataAdapter
        dataApdap.SelectCommand = cmd
        dataApdap.Fill(dt)
        Return dt
    End Function
End Class
